<html>
<head>
<title>ShotDev.Com Tutorial</title>
  <style>
	#backg{
		background: #191919 url(images/img04.jpg) repeat;
		font-size: 100px;
		margin: 200;
		color: yellow;
		}
	#enter{

	}
	#whitecolor{
		color: white;
	}
  </style>
</head>
<body id="backg">
<?php
	$objConnect = oci_connect("iss","password","orcl");

	$strSQL = "UPDATE iss.NHAN_VIEN SET ";
	$strSQL .="HO = '".$_POST["txtHO"]."' ";
	$strSQL .=",TEN = '".$_POST["txtTEN"]."' ";
	$strSQL .=",MA_NV = '".$_POST["txtMA_NV"]."' ";
	$strSQL .=",NGAY_SINH = '".$_POST["txtNGAY_SINH"]."' ";
	$strSQL .=",EMAIL = '".$_POST["txtEMAIL"]."' ";
	$strSQL .=",MS_THUE = '".$_POST["txtMS_THUE"]."' ";
	$strSQL .=",LUONG = '".$_POST["txtLUONG"]."' ";
	$strSQL .=",MA_TP = '".$_POST["txtMA_TP"]."' ";
	$strSQL .=",MA_PB = '".$_POST["txtMA_PB"]."' ";
	
	$strSQL .="WHERE MA_NV= '".$_GET["ID_NV"]."' ";
	$objParse = oci_parse($objConnect, $strSQL);
	$objExecute = oci_execute($objParse);
	if($objExecute)
	{
		oci_commit($objConnect); //*** Commit Transaction ***//
		echo "Save completed."; 
	}
	else
	{
		oci_rollback($objConnect); //*** RollBack Transaction ***//
		$e = oci_error($objParse); 
		echo "Error Save [".$e['message']."]";
	}
	oci_close($objConnect);
?>
<br>
<a id="whitecolor" href="/assiss/issassignment.php">Back to Homepage</a>
</body>
</html>
